<%@ page import="java.sql.*,com.bjsxt.softrc.test.dbpool.*" contentType="text/html; charset=gbk" %>
<%
	Connection conn = DBCPConn.getConnection();
	PreparedStatement  sqlStatement = null;
	String sql = "select * from _user ";
		ResultSet rs = null;
		try {
			sqlStatement = conn.prepareStatement(sql);
			rs = sqlStatement.executeQuery();
			while(rs.next()){
				System.out.println(rs.getString("uname"));
			}
		}catch (SQLException e) {
			e.printStackTrace();
		}finally{
			conn.close();
		}
%>